package com.beerandjesus.sportofkings.handicapper.dao;

import com.beerandjesus.sportofkings.handicapper.model.TurfSire;

import java.sql.Connection;

/**
 * Date: Jun 7, 2012
 * Time: 6:21:51 PM
 */
public interface TurfSireDAO extends AbstractDAO {

    /**
     * Build (or rebuild) the turf sire database from scratch
     * @param connection
     * @throws DAOException
     */
    void buildDatabase(Connection connection) throws DAOException;

    /**
     * Get a count of rows in the turf sire database
     * @param connection
     * @throws DAOException
     * @return int The row count
     */
    int getRowCount(Connection connection) throws DAOException;

    /**
     * Get a turf sire record by name
     * @param name
     * @param connection
     * @return
     * @throws DAOException
     */
    TurfSire getTurfSireByName(String name, Connection connection) throws DAOException;

}
